clear all
set more off 

cd "$Mydirectory1/1_DataSources/PSID97_CrossSection"

   #delimit ;

   **************************************************************************
      Label           : fim12442_sib_5_wide
      Rows            : 2092
      Columns         : 43
      ASCII File Date : May 19, 2022
   *************************************************************************;


   infix 
            ER30001               1 - 4    
            ER30002               5 - 7    
            SEX                   8 - 8    
            ID68_S01              9 - 12   
            PN_S01               13 - 15   
            SEX_S01              16 - 16   
            TYPE_S01             17 - 17   
            ID68_S02             18 - 21   
            PN_S02               22 - 24   
            SEX_S02              25 - 25   
            TYPE_S02             26 - 26   
            ID68_S03             27 - 30   
            PN_S03               31 - 33   
            SEX_S03              34 - 34   
            TYPE_S03             35 - 35   
            ID68_S04             36 - 39   
            PN_S04               40 - 42   
            SEX_S04              43 - 43   
            TYPE_S04             44 - 44   
            ID68_S05             45 - 48   
            PN_S05               49 - 51   
            SEX_S05              52 - 52   
            TYPE_S05             53 - 53   
            ID68_S06             54 - 57   
            PN_S06               58 - 60   
            SEX_S06              61 - 61   
            TYPE_S06             62 - 62   
            ID68_S07             63 - 66   
            PN_S07               67 - 69   
            SEX_S07              70 - 70   
            TYPE_S07             71 - 71   
            ID68_S08             72 - 75   
            PN_S08               76 - 78   
            SEX_S08              79 - 79   
            TYPE_S08             80 - 80   
            ID68_S09             81 - 84   
            PN_S09               85 - 87   
            SEX_S09              88 - 88   
            TYPE_S09             89 - 89   
            ID68_S10             90 - 93   
            PN_S10               94 - 96   
            SEX_S10              97 - 97   
            TYPE_S10             98 - 98   
   using ./rawdata/sib_map_wide.txt, clear 
   ;
   label variable  ER30001              "1968 INTERVIEW # OF INDIVIDUAL" ;
   label variable  ER30002              "PERSON # OF INDIVIDUAL" ;
   label variable  SEX                  "GENDER OF INDIVIDUAL" ;
   label variable  ID68_S01             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S01               "PERSON # OF SIBLING" ;
   label variable  SEX_S01              "GENDER OF SIBLING" ;
   label variable  TYPE_S01             "TYPE OF SIBLING" ;
   label variable  ID68_S02             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S02               "PERSON # OF SIBLING" ;
   label variable  SEX_S02              "GENDER OF SIBLING" ;
   label variable  TYPE_S02             "TYPE OF SIBLING" ;
   label variable  ID68_S03             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S03               "PERSON # OF SIBLING" ;
   label variable  SEX_S03              "GENDER OF SIBLING" ;
   label variable  TYPE_S03             "TYPE OF SIBLING" ;
   label variable  ID68_S04             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S04               "PERSON # OF SIBLING" ;
   label variable  SEX_S04              "GENDER OF SIBLING" ;
   label variable  TYPE_S04             "TYPE OF SIBLING" ;
   label variable  ID68_S05             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S05               "PERSON # OF SIBLING" ;
   label variable  SEX_S05              "GENDER OF SIBLING" ;
   label variable  TYPE_S05             "TYPE OF SIBLING" ;
   label variable  ID68_S06             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S06               "PERSON # OF SIBLING" ;
   label variable  SEX_S06              "GENDER OF SIBLING" ;
   label variable  TYPE_S06             "TYPE OF SIBLING" ;
   label variable  ID68_S07             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S07               "PERSON # OF SIBLING" ;
   label variable  SEX_S07              "GENDER OF SIBLING" ;
   label variable  TYPE_S07             "TYPE OF SIBLING" ;
   label variable  ID68_S08             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S08               "PERSON # OF SIBLING" ;
   label variable  SEX_S08              "GENDER OF SIBLING" ;
   label variable  TYPE_S08             "TYPE OF SIBLING" ;
   label variable  ID68_S09             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S09               "PERSON # OF SIBLING" ;
   label variable  SEX_S09              "GENDER OF SIBLING" ;
   label variable  TYPE_S09             "TYPE OF SIBLING" ;
   label variable  ID68_S10             "1968 INTERVIEW # OF SIBLING" ;
   label variable  PN_S10               "PERSON # OF SIBLING" ;
   label variable  SEX_S10              "GENDER OF SIBLING" ;
   label variable  TYPE_S10             "TYPE OF SIBLING" ;

   #delimit cr 

   sort ER30001 ER30002 
   compress
   save ./output/sib_map_wide, replace

